用java连接到firebird/odbc（orgaMax）数据库时出错

Question

Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS Exception. 3
35544344. I/O error during "CreateFile (open)" operation for file "C:\PROGRAMMDA
TA\DELTRA\ORGAMAX\DB\DB1.FDB"
Error while trying to open file
null
        at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:120
)
        at org.firebirdsql.jdbc.AbstractDriver.connect(AbstractDriver.java:136)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at at.orgamax.connector.Connector.main(Connector.java:1
9)
Caused by: org.firebirdsql.gds.GDSException: I/O error during "CreateFile (open)
" operation for file "C:\PROGRAMMDATA\DELTRA\ORGAMAX\DB\DB1.FDB"
Error while trying to open file
null
        at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(Ab
stractJavaGDSImpl.java:2120)
        at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(Abs
tractJavaGDSImpl.java:2070)
        at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.internalAttachDatab
ase(AbstractJavaGDSImpl.java:461)
        at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase(A
bstractJavaGDSImpl.java:409)
        at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.ja
va:105)
        at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnectio
n(FBManagedConnectionFactory.java:509)
        at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(
FBStandAloneConnectionManager.java:65)
        at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:118
)
        ... 4 more

import java.sql.*;
import java.util.Properties;

public class Connector {

    public static void main ( String[] args ) throws SQLException, ClassNotFoundException {
        Class.forName( "org.firebirdsql.jdbc.FBDriver" );

        System.out.println( "Starting orgaMax Connector Version 0.1" );
        System.out.println( "Connecting to the orgaMax Database" );

        Properties props = new Properties( );
        props.setProperty( "user", "OMODBCALLREAD" );
        props.setProperty( "password", "tKiulB3e" );
        props.setProperty( "encoding", "ISO8859_1" );

        Connection connection = DriverManager.getConnection(
                "jdbc:firebirdsql:127.0.0.1/5143:C:/ProgrammData/Deltra/orgaMAX/DB/DB1.fdb",
                props );

        System.out.println( "Successfully connected to the orgaMax Database." );

        spitOutAllTableRows( "BAS_ARTICLES", connection );
    }

    public static void spitOutAllTableRows ( String tableName, Connection conn ) {
        try {
            System.out.println( "current " + tableName + " is:" );
            try ( PreparedStatement selectStmt = conn.prepareStatement(
                    "SELECT * from " + tableName, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY );
                  ResultSet rs = selectStmt.executeQuery( ) ) {
                if ( !rs.isBeforeFirst( ) ) {
                    System.out.println( "no rows found" );
                } else {
                    System.out.println( "types:" );
                    for ( int i = 0; i < rs.getMetaData( ).getColumnCount( ); i++ ) {
                        System.out.print( rs.getMetaData( ).getColumnName( i + 1 ) + ":" + rs.getMetaData( ).getColumnTypeName( i + 1 ) + " " );
                    }
                    System.out.println( );
                    while ( rs.next( ) ) {
                        for ( int i = 1; i < rs.getMetaData( ).getColumnCount( ) + 1; i++ ) {
                            System.out.print( " " + rs.getMetaData( ).getColumnName( i ) + "=" + rs.getObject( i ) );
                        }
                        System.out.println( "" );
                    }
                }
            }
        } catch ( SQLException e ) {
            throw new RuntimeException( e );
        }
    }
}

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>at.orgamax.connector</groupId>
    <artifactId>connector</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.16</version>
        </dependency>

        <dependency>
            <groupId>org.firebirdsql.jdbc</groupId>
            <artifactId>jaybird-jdk18</artifactId>
            <version>2.2.12</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-jar-plugin</artifactId>
                <version>3.2.0</version>
                <configuration>
                    <archive>
                        <manifestFile>${project.build.outputDirectory}/META-INF/MANIFEST.MF</manifestFile>
                    </archive>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-assembly-plugin</artifactId>
                <executions>
                    <execution>
                        <phase>package</phase>
                        <goals>
                            <goal>single</goal>
                        </goals>
                        <configuration>
                            <archive>
                                <manifest>
                                    <mainClass>
                                       at.orgamax.connector.Connector
                                    </mainClass>
                                </manifest>
                            </archive>
                            <descriptorRefs>
                                <descriptorRef>jar-with-dependencies</descriptorRef>
                            </descriptorRefs>
                        </configuration>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

</project>

如果有人能在这里帮忙，我真的很高兴。

Answer 1

Connection connection = DriverManager.getConnection(
                "jdbc:firebirdsql:127.0.0.1/5143:C:/ProgrammData/Deltra

计算单词“program”中的“m”个字母

您的ODBC信息显示一个字母。

您的Java源代码显示了两个字母。