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 46 added 25 lines
-------------------------------------------------------------\\
!POSSIBILI ERRORI
\\
1) se quando provi a collegarti ad un db da un sito compare un errore del tipo:\\
\\
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