> I have a Java app that is adding a new record to the database. I
> can execute SELECTs no problem but when I try to insert I get this
> error:
>
> org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error
> during
> "CreateFile (open)" operation for Al/pool/Swimming.gdb"
> Error while trying to open file
> null
> Reason: I/O error during "CreateFile (open)" operation for file
> "Al/pool/Swimming.gdb"
> Error while trying to open file
> null
>
> I'm pretty sure this is a Firebird issue but here is my code:

What about specifying correct URL? URL must have form:

jdbc:firebirdsql:server/3050:/path/to/database.gdb

(or in Windows case jdbc:firebirdsql:server/3050:c:/path/to/database.gdb)

Best regards,
Roman Rokytskyy