Help - Can't connect to production db
Help - Can't connect to production db
- Subject: Help - Can't connect to production db
- From: James Cicenia <email@hidden>
- Date: Sun, 20 Nov 2005 23:11:36 -0600
Hello -
Somehow, something was changed and now I cannot for the life of me
have my app connect to the mysql database.
Here is some info:
Received Model Added Notification of EOModelPrototypes
URL is NOT null
Plugin is Default
Set Dictionary
Checking JDBC connection with information {plugin = ""; jdbc2Info =
{NON_NULLABLE_COLUMNS = "T"; ANSI92_CONFORMANCE = "ANSI92EntryLevel";
DRIVER_NAME = "MySQL-AB JDBC Driver"; DBMS_NAME = "MySQL"; typeInfo =
{BINARY = {defaultJDBCType = ("BINARY"); createParams = "1"; maxScale
= "0"; minScale = "0"; isNullable = "T"; isSearchable = "T";
precision = "255"; }; ENUM = {defaultJDBCType = ("VARCHAR");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "65535"; }; SET = {defaultJDBCType =
("VARCHAR"); createParams = "1"; maxScale = "0"; minScale = "0";
isNullable = "T"; isSearchable = "T"; precision = "64"; }; TINYINT =
{defaultJDBCType = ("TINYINT"); createParams = "1"; maxScale = "0";
minScale = "0"; isNullable = "T"; isSearchable = "T"; precision =
"3"; }; SMALLINT = {defaultJDBCType = ("SMALLINT"); createParams =
"1"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable =
"T"; precision = "5"; }; VARCHAR = {defaultJDBCType = ("VARCHAR");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "255"; }; REAL = {defaultJDBCType =
("DOUBLE"); createParams = "2"; maxScale = "308"; minScale = "-308";
isNullable = "T"; isSearchable = "T"; precision = "17"; }; TIME =
{defaultJDBCType = ("TIME"); createParams = "1"; maxScale = "0";
minScale = "0"; isNullable = "T"; isSearchable = "T"; precision =
"0"; }; VARBINARY = {defaultJDBCType = ("VARBINARY"); createParams =
"1"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable =
"T"; precision = "255"; }; INT = {defaultJDBCType = ("INTEGER");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "10"; }; DOUBLE = {defaultJDBCType =
("FLOAT", "DOUBLE"); createParams = "2"; maxScale = "308"; minScale =
"-308"; isNullable = "T"; isSearchable = "T"; precision = "17"; };
MEDIUMBLOB = {defaultJDBCType = ("LONG VARBINARY"); createParams =
"0"; maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable =
"T"; precision = "16777215"; }; CHAR = {defaultJDBCType = ("CHAR");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "255"; }; NUMERIC = {defaultJDBCType
= ("NUMERIC"); createParams = "2"; maxScale = "308"; minScale =
"308"; isNullable = "T"; isSearchable = "T"; precision = "17"; };
LONGBLOB = {defaultJDBCType = ("LONG VARBINARY"); createParams = "0";
maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T";
precision = "2147483647"; }; BLOB = {defaultJDBCType = ("LONG
VARBINARY"); createParams = "0"; maxScale = "0"; minScale = "0";
isNullable = "T"; isSearchable = "T"; precision = "65535"; }; INTEGER
= {defaultJDBCType = ("INTEGER"); createParams = "1"; maxScale = "0";
minScale = "0"; isNullable = "T"; isSearchable = "T"; precision =
"10"; }; MEDIUMTEXT = {defaultJDBCType = ("LONG VARCHAR");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "16777215"; }; LONG VARBINARY =
{defaultJDBCType = ("LONG VARBINARY"); createParams = "1"; maxScale =
"0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision
= "16777215"; }; TIMESTAMP = {defaultJDBCType = ("TIMESTAMP");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "0"; }; LONGTEXT = {defaultJDBCType =
("LONG VARCHAR"); createParams = "1"; maxScale = "0"; minScale = "0";
isNullable = "T"; isSearchable = "T"; precision = "2147483647"; };
BOOL = {defaultJDBCType = ("BIT"); createParams = "1"; maxScale =
"0"; minScale = "0"; isNullable = "T"; isSearchable = "T"; precision
= "1"; }; TINYTEXT = {defaultJDBCType = ("LONG VARCHAR");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "255"; }; TEXT = {defaultJDBCType =
("LONG VARCHAR"); createParams = "1"; maxScale = "0"; minScale = "0";
isNullable = "T"; isSearchable = "T"; precision = "65535"; }; BIT =
{defaultJDBCType = ("BIT"); createParams = "1"; maxScale = "0";
minScale = "0"; isNullable = "T"; isSearchable = "T"; precision =
"1"; }; DATE = {defaultJDBCType = ("DATE"); createParams = "1";
maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T";
precision = "0"; }; BIGINT = {defaultJDBCType = ("BIGINT");
createParams = "1"; maxScale = "0"; minScale = "0"; isNullable = "T";
isSearchable = "T"; precision = "19"; }; DECIMAL = {defaultJDBCType =
("DECIMAL"); createParams = "2"; maxScale = "308"; minScale = "-308";
isNullable = "T"; isSearchable = "T"; precision = "17"; }; DOUBLE
PRECISION = {defaultJDBCType = ("DOUBLE"); createParams = "2";
maxScale = "308"; minScale = "-308"; isNullable = "T"; isSearchable =
"T"; precision = "17"; }; TINYBLOB = {defaultJDBCType = ("LONG
VARBINARY"); createParams = "0"; maxScale = "0"; minScale = "0";
isNullable = "T"; isSearchable = "T"; precision = "255"; }; LONG
VARCHAR = {defaultJDBCType = ("LONG VARCHAR"); createParams = "1";
maxScale = "0"; minScale = "0"; isNullable = "T"; isSearchable = "T";
precision = "16777215"; }; MEDIUMINT = {defaultJDBCType =
("INTEGER"); createParams = "1"; maxScale = "0"; minScale = "0";
isNullable = "T"; isSearchable = "T"; precision = "7"; }; DATETIME =
{defaultJDBCType = ("TIMESTAMP"); createParams = "1"; maxScale = "0";
minScale = "0"; isNullable = "T"; isSearchable = "T"; precision =
"0"; }; FLOAT = {defaultJDBCType = ("REAL"); createParams = "2";
maxScale = "38"; minScale = "-38"; isNullable = "T"; isSearchable =
"T"; precision = "10"; }; }; IDENTIFIER_QUOTE_STRING = "`";
DRIVER_VER = "mysql-connector-java-3.0.10-stable ( $Date: 2004/01/13
21:56:18 $, $Revision: 1.27.2.33 $ )"; STRING_FUNCTIONS =
"ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS
,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGT
H,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_
LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDE
X,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,T
RIM,UCASE,UPPER"; }; username = "webobjects"; driver =
"com.mysql.jdbc.Driver";
and finally the error:
Trying to create plugin...
Created plugin com.webobjects.jdbcadaptor.MySQLPlugIn
Trying to load JDBC driver com.mysql.jdbc.Driver...
Successfully loaded JDBC driver com.mysql.jdbc.Driver
JDBC driver and plugin are loaded, trying to connect...
Error: Exception thrown while connecting.
Check exception message carefully.
[2005-11-20 22:59:39 CST] <main>
com.webobjects.jdbcadaptor.JDBCAdaptorException: Communications link
failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect
(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)
at com.mysql.jdbc.Connection.<init>(Connection.java:1474)
at com.mysql.jdbc.NonRegisteringDriver.connect
(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.webobjects.jdbcadaptor.JDBCContext.connect
(JDBCContext.java:207)
at com.webobjects.jdbcadaptor.JDBCContext._tryConnect
(JDBCContext.java:331)
at com.webobjects.jdbcadaptor.JDBCContext._channelWillOpen
(JDBCContext.java:468)
at com.webobjects.jdbcadaptor.JDBCChannel.openChannel
(JDBCChannel.java:81)
at
com.webobjects.jdbcadaptor.JDBCAdaptor.assertConnectionDictionaryIsValid
(JDBCAdaptor.java:328)
at com.tos.EOFJDBCConnectionAnalyzer.testConnection
(EOFJDBCConnectionAnalyzer.java:218)
at com.tos.EOFJDBCConnectionAnalyzer.analyzeConnection
(EOFJDBCConnectionAnalyzer.java:89)
at com.tos.EOFJDBCConnectionAnalyzer.<init>
(EOFJDBCConnectionAnalyzer.java:38)
at com.tos.EOFJDBCConnectionAnalyzer.<init>
(EOFJDBCConnectionAnalyzer.java:52)
at com.tos.EOFJDBCConnectionAnalyzer.<init>
(EOFJDBCConnectionAnalyzer.java:68)
at com.tos.Application.<init>(Application.java:136)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0
(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance
(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
-- VISUAL BLOCK --
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden