View Attach Info

Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-7) was last changed on 15-Oct-2010 16:14 by RaffaelePedrini  

This page was created on 14-Apr-2010 14:30 by RaffaelePedrini

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 47 added one line
!POSSIBILI ERRORI
At line 48 changed one line
NOTA: se compare un errore del tipo \\
1) se quando provi a collegarti ad un db da un sito compare un errore del tipo:\\
At line 51 added 20 lines
ERRORE:com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001\\
\\
Vuol dire che devi settare in /etc/hosts\\
\\
127.0.0.1 localhost.localdomain localhost databaseDB2 NOMESERVER
\\
in particolare è utili databaseDB2 perchè nel virtual di tomcat poi lo usi così\\
url=jdbc:db2://databaseDB2:50000/NOMEDB
\\
2) se quando provi a collegarti ad un db da un sito compare un errore del tipo:\\
\\
ERRORE:com.ibm.db2.jcc.am.SqlSyntaxErrorException: "UTENTEDB2" does not have the required authorization or privilege to perform operation "SELECT" on object "SCHEMA.TABLE".. SQLCODE=-551, SQLSTATE=42501, DRIVER=3.59.81\\
\\
Vuol dire che hai creato il database in questione non con l'utente del db2 ma da utente ROOT...devi droppare il db e ricrearlo facendo\\
\\
su UTENTEDB2\\
(nota: in /etc/passwd assegnare all'utente db2 una shell bash)
\\
\\
Version Date Modified Size Author Changes ... Change note
7 15-Oct-2010 16:14 8.864 kB RaffaelePedrini to previous
6 15-Oct-2010 16:14 8.862 kB RaffaelePedrini to previous | to last
5 15-Oct-2010 16:13 8.882 kB RaffaelePedrini to previous | to last
4 15-Oct-2010 16:12 8.914 kB RaffaelePedrini to previous | to last
3 15-Oct-2010 16:04 7.757 kB RaffaelePedrini to previous | to last
2 14-Apr-2010 14:30 7.644 kB RaffaelePedrini to previous | to last
1 14-Apr-2010 14:30 7.594 kB RaffaelePedrini to last
« This page (revision-7) was last changed on 15-Oct-2010 16:14 by RaffaelePedrini